{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-05-31T09:23:59.030137Z",
     "start_time": "2024-05-31T09:23:59.007145400Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "             id                   name  score star  sale_count  \\\n0    1497883331                北京环球度假区    0.0    无       16621   \n1     777857128                  八达岭长城    4.1   5A       12285   \n2    4268080051                    颐和园    4.1   5A       10140   \n3    1699488273                北京野生动物园    3.5   4A        9962   \n4    1053903287                   天坛公园    4.0   5A        8661   \n..          ...                    ...    ...  ...         ...   \n670   873783513  亮剑盟真人cs拓展 (大兴北普陀影视城店)    0.0    无          72   \n671  4095926285                 北京君和温泉    0.0    无          32   \n672   118255110                    白羊沟    3.5    无          98   \n673  3590617904                  故宫北院区    0.0    无          16   \n674   492926817              北京蓝海特训营基地    0.0    无          43   \n\n                                                 intro               address  \\\n0                                            大片世界，在此成真         北京市通州区北京环球度假区   \n1                                              不到长城非好汉     北京市延庆区G6京藏高速58号出口   \n2                                          走入清朝皇帝的皇家园林        北京市海淀区新建宫门路19号   \n3                                            近距离观赏野生动物     北京市大兴区榆垡镇永定河畔的万亩林   \n4                                          明清时期皇帝祭天的地方          北京市东城区天坛路甲1号   \n..                                                 ...                   ...   \n670                                                  无   北京市大兴区104国道北普陀影视城北门   \n671                                                  无  北京市顺义区李魏路宣庄户段8号院86号楼   \n672  白羊沟自然风景区位于昌平区流村镇西北部，距357公共汽车流村站八公里，整个景区遍布奇花异草、...      北京昌平区流村镇白羊沟自然风景区   \n673                                                  无           北京海淀区上庄北崔家窑   \n674                                                  无   北京市房山区阎村小十三里紫码路西50米   \n\n     price  discount                            point   longitude   latitude  \n0    505.0       8.6               116.68782,39.86099  116.687820  39.860990  \n1     39.5       3.9             116.024067,40.362639  116.024067  40.362639  \n2     30.0      10.0           116.2802339,40.0088172  116.280234  40.008817  \n3    145.0       9.6             116.340954,39.502139  116.340954  39.502139  \n4     15.0       7.5             116.419289,39.889918  116.419289  39.889918  \n..     ...       ...                              ...         ...        ...  \n670  200.0      10.0             116.458336,39.741574  116.458336  39.741574  \n671  216.0      10.0                          0.0,0.0    0.000000   0.000000  \n672  500.0      10.0  116.01716224571,40.207473616187  116.017162  40.207474  \n673  268.0      10.0                          0.0,0.0    0.000000   0.000000  \n674  299.0      10.0                          0.0,0.0    0.000000   0.000000  \n\n[675 rows x 12 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>name</th>\n      <th>score</th>\n      <th>star</th>\n      <th>sale_count</th>\n      <th>intro</th>\n      <th>address</th>\n      <th>price</th>\n      <th>discount</th>\n      <th>point</th>\n      <th>longitude</th>\n      <th>latitude</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1497883331</td>\n      <td>北京环球度假区</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>16621</td>\n      <td>大片世界，在此成真</td>\n      <td>北京市通州区北京环球度假区</td>\n      <td>505.0</td>\n      <td>8.6</td>\n      <td>116.68782,39.86099</td>\n      <td>116.687820</td>\n      <td>39.860990</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>777857128</td>\n      <td>八达岭长城</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>12285</td>\n      <td>不到长城非好汉</td>\n      <td>北京市延庆区G6京藏高速58号出口</td>\n      <td>39.5</td>\n      <td>3.9</td>\n      <td>116.024067,40.362639</td>\n      <td>116.024067</td>\n      <td>40.362639</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>4268080051</td>\n      <td>颐和园</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>10140</td>\n      <td>走入清朝皇帝的皇家园林</td>\n      <td>北京市海淀区新建宫门路19号</td>\n      <td>30.0</td>\n      <td>10.0</td>\n      <td>116.2802339,40.0088172</td>\n      <td>116.280234</td>\n      <td>40.008817</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1699488273</td>\n      <td>北京野生动物园</td>\n      <td>3.5</td>\n      <td>4A</td>\n      <td>9962</td>\n      <td>近距离观赏野生动物</td>\n      <td>北京市大兴区榆垡镇永定河畔的万亩林</td>\n      <td>145.0</td>\n      <td>9.6</td>\n      <td>116.340954,39.502139</td>\n      <td>116.340954</td>\n      <td>39.502139</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1053903287</td>\n      <td>天坛公园</td>\n      <td>4.0</td>\n      <td>5A</td>\n      <td>8661</td>\n      <td>明清时期皇帝祭天的地方</td>\n      <td>北京市东城区天坛路甲1号</td>\n      <td>15.0</td>\n      <td>7.5</td>\n      <td>116.419289,39.889918</td>\n      <td>116.419289</td>\n      <td>39.889918</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>670</th>\n      <td>873783513</td>\n      <td>亮剑盟真人cs拓展 (大兴北普陀影视城店)</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>72</td>\n      <td>无</td>\n      <td>北京市大兴区104国道北普陀影视城北门</td>\n      <td>200.0</td>\n      <td>10.0</td>\n      <td>116.458336,39.741574</td>\n      <td>116.458336</td>\n      <td>39.741574</td>\n    </tr>\n    <tr>\n      <th>671</th>\n      <td>4095926285</td>\n      <td>北京君和温泉</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>32</td>\n      <td>无</td>\n      <td>北京市顺义区李魏路宣庄户段8号院86号楼</td>\n      <td>216.0</td>\n      <td>10.0</td>\n      <td>0.0,0.0</td>\n      <td>0.000000</td>\n      <td>0.000000</td>\n    </tr>\n    <tr>\n      <th>672</th>\n      <td>118255110</td>\n      <td>白羊沟</td>\n      <td>3.5</td>\n      <td>无</td>\n      <td>98</td>\n      <td>白羊沟自然风景区位于昌平区流村镇西北部，距357公共汽车流村站八公里，整个景区遍布奇花异草、...</td>\n      <td>北京昌平区流村镇白羊沟自然风景区</td>\n      <td>500.0</td>\n      <td>10.0</td>\n      <td>116.01716224571,40.207473616187</td>\n      <td>116.017162</td>\n      <td>40.207474</td>\n    </tr>\n    <tr>\n      <th>673</th>\n      <td>3590617904</td>\n      <td>故宫北院区</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>16</td>\n      <td>无</td>\n      <td>北京海淀区上庄北崔家窑</td>\n      <td>268.0</td>\n      <td>10.0</td>\n      <td>0.0,0.0</td>\n      <td>0.000000</td>\n      <td>0.000000</td>\n    </tr>\n    <tr>\n      <th>674</th>\n      <td>492926817</td>\n      <td>北京蓝海特训营基地</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>43</td>\n      <td>无</td>\n      <td>北京市房山区阎村小十三里紫码路西50米</td>\n      <td>299.0</td>\n      <td>10.0</td>\n      <td>0.0,0.0</td>\n      <td>0.000000</td>\n      <td>0.000000</td>\n    </tr>\n  </tbody>\n</table>\n<p>675 rows × 12 columns</p>\n</div>"
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"static/data/sight_pre.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [
    {
     "data": {
      "text/plain": "           id     name  score star  sale_count         intro  \\\n0  1497883331  北京环球度假区    0.0    无       16621     大片世界，在此成真   \n1   777857128    八达岭长城    4.1   5A       12285       不到长城非好汉   \n2  4268080051      颐和园    4.1   5A       10140   走入清朝皇帝的皇家园林   \n3  1699488273  北京野生动物园    3.5   4A        9962     近距离观赏野生动物   \n4  1053903287     天坛公园    4.0   5A        8661   明清时期皇帝祭天的地方   \n7  1577458228      珍宝馆    0.0    无        7433     乾隆慈禧曾居住在这   \n5  3070792170      恭王府    3.7   5A        6864   旧时清朝大臣和珅的府邸   \n6   989946426    故宫博物院    5.0   5A        5760  穿越明清两朝的皇家宫殿群   \n8  1427399043      圆明园    3.8   5A        5564   毁于战火的清代皇家园林   \n9  1987315843    慕田峪长城    3.5   5A        4673     看万里长城山河壮丽   \n\n             address  price  discount                   point  \n0      北京市通州区北京环球度假区  505.0       8.6      116.68782,39.86099  \n1  北京市延庆区G6京藏高速58号出口   39.5       3.9    116.024067,40.362639  \n2     北京市海淀区新建宫门路19号   30.0      10.0  116.2802339,40.0088172  \n3  北京市大兴区榆垡镇永定河畔的万亩林  145.0       9.6    116.340954,39.502139  \n4       北京市东城区天坛路甲1号   15.0       7.5    116.419289,39.889918  \n7         故宫博物院宁寿宫内    35.0       3.9    116.406346,39.925979  \n5      北京市西城区前海西街17号   40.0      10.0    116.392599,39.943381  \n6       北京市东城区景山前街4号   80.0      10.0    116.403414,39.924091  \n8      北京市海淀区清华西路28号   64.0      10.0    116.309736,40.016191  \n9      北京市怀柔区渤海镇慕田峪村   60.0      10.0    116.575896,40.440146  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>name</th>\n      <th>score</th>\n      <th>star</th>\n      <th>sale_count</th>\n      <th>intro</th>\n      <th>address</th>\n      <th>price</th>\n      <th>discount</th>\n      <th>point</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1497883331</td>\n      <td>北京环球度假区</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>16621</td>\n      <td>大片世界，在此成真</td>\n      <td>北京市通州区北京环球度假区</td>\n      <td>505.0</td>\n      <td>8.6</td>\n      <td>116.68782,39.86099</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>777857128</td>\n      <td>八达岭长城</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>12285</td>\n      <td>不到长城非好汉</td>\n      <td>北京市延庆区G6京藏高速58号出口</td>\n      <td>39.5</td>\n      <td>3.9</td>\n      <td>116.024067,40.362639</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>4268080051</td>\n      <td>颐和园</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>10140</td>\n      <td>走入清朝皇帝的皇家园林</td>\n      <td>北京市海淀区新建宫门路19号</td>\n      <td>30.0</td>\n      <td>10.0</td>\n      <td>116.2802339,40.0088172</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1699488273</td>\n      <td>北京野生动物园</td>\n      <td>3.5</td>\n      <td>4A</td>\n      <td>9962</td>\n      <td>近距离观赏野生动物</td>\n      <td>北京市大兴区榆垡镇永定河畔的万亩林</td>\n      <td>145.0</td>\n      <td>9.6</td>\n      <td>116.340954,39.502139</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1053903287</td>\n      <td>天坛公园</td>\n      <td>4.0</td>\n      <td>5A</td>\n      <td>8661</td>\n      <td>明清时期皇帝祭天的地方</td>\n      <td>北京市东城区天坛路甲1号</td>\n      <td>15.0</td>\n      <td>7.5</td>\n      <td>116.419289,39.889918</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>1577458228</td>\n      <td>珍宝馆</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>7433</td>\n      <td>乾隆慈禧曾居住在这</td>\n      <td>故宫博物院宁寿宫内</td>\n      <td>35.0</td>\n      <td>3.9</td>\n      <td>116.406346,39.925979</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>3070792170</td>\n      <td>恭王府</td>\n      <td>3.7</td>\n      <td>5A</td>\n      <td>6864</td>\n      <td>旧时清朝大臣和珅的府邸</td>\n      <td>北京市西城区前海西街17号</td>\n      <td>40.0</td>\n      <td>10.0</td>\n      <td>116.392599,39.943381</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>989946426</td>\n      <td>故宫博物院</td>\n      <td>5.0</td>\n      <td>5A</td>\n      <td>5760</td>\n      <td>穿越明清两朝的皇家宫殿群</td>\n      <td>北京市东城区景山前街4号</td>\n      <td>80.0</td>\n      <td>10.0</td>\n      <td>116.403414,39.924091</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>1427399043</td>\n      <td>圆明园</td>\n      <td>3.8</td>\n      <td>5A</td>\n      <td>5564</td>\n      <td>毁于战火的清代皇家园林</td>\n      <td>北京市海淀区清华西路28号</td>\n      <td>64.0</td>\n      <td>10.0</td>\n      <td>116.309736,40.016191</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>1987315843</td>\n      <td>慕田峪长城</td>\n      <td>3.5</td>\n      <td>5A</td>\n      <td>4673</td>\n      <td>看万里长城山河壮丽</td>\n      <td>北京市怀柔区渤海镇慕田峪村</td>\n      <td>60.0</td>\n      <td>10.0</td>\n      <td>116.575896,40.440146</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sale_count_desc = df.sort_values(by=\"sale_count\", ascending=False).head(10)\n",
    "sale_count_desc"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T08:08:57.205385900Z",
     "start_time": "2024-05-31T08:08:57.192652500Z"
    }
   },
   "id": "252ef889bdc686c1"
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [
    {
     "data": {
      "text/plain": "             id   name  score star  sale_count         intro  \\\n6     989946426  故宫博物院    5.0   5A        5760  穿越明清两朝的皇家宫殿群   \n16   4194325354  天安门广场    5.0    无        3234      祖国的象征与心脏   \n11     89108430     鸟巢    4.2    无        4540     新北京的标志性建筑   \n2    4268080051    颐和园    4.1   5A       10140   走入清朝皇帝的皇家园林   \n1     777857128  八达岭长城    4.1   5A       12285       不到长城非好汉   \n358  2307385447   前门大街    4.0    无           8     京味十足的商业老街   \n4    1053903287   天坛公园    4.0   5A        8661   明清时期皇帝祭天的地方   \n146  3065369945   北京大学    3.9    无         378  皇家园林上建起的百年学府   \n77   2532223338    什刹海    3.9   4A         152    历史街区与时尚夜生活   \n21   3125362020    雍和宫    3.8    无        2258  生活过雍正与乾隆两位皇帝   \n\n                                         address  price  discount  \\\n6                                   北京市东城区景山前街4号   80.0      10.0   \n16                          北京市东城区长安街（天安门和正阳门之间）   17.0       1.7   \n11                               北京市朝阳区国家体育场南路1号   94.0       9.4   \n2                                 北京市海淀区新建宫门路19号   30.0      10.0   \n1                              北京市延庆区G6京藏高速58号出口   39.5       3.9   \n358                                   北京市东城区前门大街   28.0       9.3   \n4                                   北京市东城区天坛路甲1号   15.0       7.5   \n146                                 北京市海淀区颐和园路5号   20.0       4.4   \n77   北京市西城区东起地安门外大街北侧、南至新街口北大街、西至新街口豁口、北至钟、鼓楼的区域  143.0       9.5   \n21                                北京市东城区雍和宫大街12号   27.0       9.0   \n\n                      point  \n6      116.403414,39.924091  \n16     116.404091,39.910095  \n11     116.402845,39.999285  \n2    116.2802339,40.0088172  \n1      116.024067,40.362639  \n358     116.40452,39.899651  \n4      116.419289,39.889918  \n146    116.316833,39.998877  \n77     116.391243,39.948373  \n21     116.423776,39.953314  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>name</th>\n      <th>score</th>\n      <th>star</th>\n      <th>sale_count</th>\n      <th>intro</th>\n      <th>address</th>\n      <th>price</th>\n      <th>discount</th>\n      <th>point</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>6</th>\n      <td>989946426</td>\n      <td>故宫博物院</td>\n      <td>5.0</td>\n      <td>5A</td>\n      <td>5760</td>\n      <td>穿越明清两朝的皇家宫殿群</td>\n      <td>北京市东城区景山前街4号</td>\n      <td>80.0</td>\n      <td>10.0</td>\n      <td>116.403414,39.924091</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>4194325354</td>\n      <td>天安门广场</td>\n      <td>5.0</td>\n      <td>无</td>\n      <td>3234</td>\n      <td>祖国的象征与心脏</td>\n      <td>北京市东城区长安街（天安门和正阳门之间）</td>\n      <td>17.0</td>\n      <td>1.7</td>\n      <td>116.404091,39.910095</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>89108430</td>\n      <td>鸟巢</td>\n      <td>4.2</td>\n      <td>无</td>\n      <td>4540</td>\n      <td>新北京的标志性建筑</td>\n      <td>北京市朝阳区国家体育场南路1号</td>\n      <td>94.0</td>\n      <td>9.4</td>\n      <td>116.402845,39.999285</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>4268080051</td>\n      <td>颐和园</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>10140</td>\n      <td>走入清朝皇帝的皇家园林</td>\n      <td>北京市海淀区新建宫门路19号</td>\n      <td>30.0</td>\n      <td>10.0</td>\n      <td>116.2802339,40.0088172</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>777857128</td>\n      <td>八达岭长城</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>12285</td>\n      <td>不到长城非好汉</td>\n      <td>北京市延庆区G6京藏高速58号出口</td>\n      <td>39.5</td>\n      <td>3.9</td>\n      <td>116.024067,40.362639</td>\n    </tr>\n    <tr>\n      <th>358</th>\n      <td>2307385447</td>\n      <td>前门大街</td>\n      <td>4.0</td>\n      <td>无</td>\n      <td>8</td>\n      <td>京味十足的商业老街</td>\n      <td>北京市东城区前门大街</td>\n      <td>28.0</td>\n      <td>9.3</td>\n      <td>116.40452,39.899651</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1053903287</td>\n      <td>天坛公园</td>\n      <td>4.0</td>\n      <td>5A</td>\n      <td>8661</td>\n      <td>明清时期皇帝祭天的地方</td>\n      <td>北京市东城区天坛路甲1号</td>\n      <td>15.0</td>\n      <td>7.5</td>\n      <td>116.419289,39.889918</td>\n    </tr>\n    <tr>\n      <th>146</th>\n      <td>3065369945</td>\n      <td>北京大学</td>\n      <td>3.9</td>\n      <td>无</td>\n      <td>378</td>\n      <td>皇家园林上建起的百年学府</td>\n      <td>北京市海淀区颐和园路5号</td>\n      <td>20.0</td>\n      <td>4.4</td>\n      <td>116.316833,39.998877</td>\n    </tr>\n    <tr>\n      <th>77</th>\n      <td>2532223338</td>\n      <td>什刹海</td>\n      <td>3.9</td>\n      <td>4A</td>\n      <td>152</td>\n      <td>历史街区与时尚夜生活</td>\n      <td>北京市西城区东起地安门外大街北侧、南至新街口北大街、西至新街口豁口、北至钟、鼓楼的区域</td>\n      <td>143.0</td>\n      <td>9.5</td>\n      <td>116.391243,39.948373</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>3125362020</td>\n      <td>雍和宫</td>\n      <td>3.8</td>\n      <td>无</td>\n      <td>2258</td>\n      <td>生活过雍正与乾隆两位皇帝</td>\n      <td>北京市东城区雍和宫大街12号</td>\n      <td>27.0</td>\n      <td>9.0</td>\n      <td>116.423776,39.953314</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score_desc = df.sort_values(by=\"score\", ascending=False).head(10)\n",
    "score_desc"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T08:09:31.168267200Z",
     "start_time": "2024-05-31T08:09:31.146914100Z"
    }
   },
   "id": "e644509fca6257e0"
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "outputs": [
    {
     "data": {
      "text/plain": "  star  name\n0   3A    11\n1   4A    67\n2   5A    10\n3    无   587",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>star</th>\n      <th>name</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>3A</td>\n      <td>11</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>4A</td>\n      <td>67</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>5A</td>\n      <td>10</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>无</td>\n      <td>587</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_count = df.groupby(\"star\")['name'].count().reset_index()\n",
    "star_count"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T08:10:37.687456Z",
     "start_time": "2024-05-31T08:10:37.672546100Z"
    }
   },
   "id": "1b7b55b4a87ed25a"
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "outputs": [
    {
     "data": {
      "text/plain": "{'data': [{'name': '北京环球度假区', 'value': ['116.68782', '39.86099']},\n  {'name': '八达岭长城', 'value': ['116.024067', '40.362639']},\n  {'name': '颐和园', 'value': ['116.2802339', '40.0088172']},\n  {'name': '北京野生动物园', 'value': ['116.340954', '39.502139']},\n  {'name': '天坛公园', 'value': ['116.419289', '39.889918']},\n  {'name': '恭王府', 'value': ['116.392599', '39.943381']},\n  {'name': '故宫博物院', 'value': ['116.403414', '39.924091']},\n  {'name': '珍宝馆', 'value': ['116.406346', '39.925979']},\n  {'name': '圆明园', 'value': ['116.309736', '40.016191']},\n  {'name': '慕田峪长城', 'value': ['116.575896', '40.440146']},\n  {'name': '北京动物园', 'value': ['116.342331', '39.947726']},\n  {'name': '鸟巢', 'value': ['116.402845', '39.999285']},\n  {'name': '北海公园', 'value': ['116.395006', '39.934167']},\n  {'name': '中国国家博物馆', 'value': ['116.408018', '39.911449']},\n  {'name': '明十三陵', 'value': ['116.231846', '40.263544']},\n  {'name': '景山公园', 'value': ['116.402966', '39.932136']},\n  {'name': '天安门广场', 'value': ['116.404091', '39.910095']},\n  {'name': '午门', 'value': ['116.403705', '39.920105']},\n  {'name': '北京海洋馆', 'value': ['116.347445', '39.950257']},\n  {'name': '北京欢乐谷', 'value': ['116.501309', '39.873868']},\n  {'name': '古北水镇', 'value': ['117.284632', '40.661046']},\n  {'name': '雍和宫', 'value': ['116.423776', '39.953314']},\n  {'name': '雁栖湖旅游区', 'value': ['116.690837', '40.403587']},\n  {'name': '升旗仪式', 'value': ['116.403931', '39.913288']},\n  {'name': '金海湖风景区', 'value': ['117.310896', '40.187348']},\n  {'name': '谷山村', 'value': ['116.065568', '39.997626']},\n  {'name': '中国科学技术馆', 'value': ['116.404938', '40.012333']},\n  {'name': '北京世界公园', 'value': ['116.293772', '39.81671']},\n  {'name': '红螺寺', 'value': ['116.634124', '40.389488']},\n  {'name': '黄花城水长城', 'value': ['116.307167', '40.419287']},\n  {'name': '潭柘寺', 'value': ['116.03762', '39.91122']},\n  {'name': '龙庆峡', 'value': ['116.009343', '40.557851']},\n  {'name': '定陵', 'value': ['116.232421', '40.30048']},\n  {'name': '世界花卉大观园', 'value': ['116.359803', '39.841376']},\n  {'name': '北京世园公园', 'value': ['115.957449', '40.450315']},\n  {'name': '八大处公园', 'value': ['116.1892118', '39.9683518']},\n  {'name': '京东石林峡', 'value': ['117.24851', '40.268794']},\n  {'name': '北京国际鲜花港', 'value': ['116.803564', '40.187688']},\n  {'name': '奥林匹克公园', 'value': ['116.399206', '39.999245']},\n  {'name': '周口店遗址博物馆', 'value': ['115.943241', '39.693589']},\n  {'name': '八奇洞', 'value': ['116.0337156', '39.8992767']},\n  {'name': '国家植物园（原北京植物园）', 'value': ['116.216152', '40.008872']},\n  {'name': '八达岭长城缆车', 'value': ['116.024067', '40.362639']},\n  {'name': '北京野鸭湖国家湿地公园', 'value': ['115.8648328', '40.4148653']},\n  {'name': '北京天文馆', 'value': ['116.34338', '39.943008']},\n  {'name': '司马台长城', 'value': ['117.292856', '40.663649']},\n  {'name': '居庸关长城', 'value': ['116.078214', '40.297394']},\n  {'name': '石景山游乐园', 'value': ['116.215231', '39.91784']},\n  {'name': '周口店北京猿人遗址公园', 'value': ['115.9374046', '39.6961276']},\n  {'name': '静之湖景区', 'value': ['116.448657', '40.24691']},\n  {'name': '北京园博园', 'value': ['116.196833', '39.882092']},\n  {'name': '小羊MoMo森林王国亲子乐园', 'value': ['116.528478', '39.975289']},\n  {'name': '北京汽车博物馆', 'value': ['116.308108', '39.835043']},\n  {'name': '戒台寺', 'value': ['116.092996', '39.87673']},\n  {'name': '云居寺', 'value': ['115.7803837', '39.6152474']},\n  {'name': '中山公园', 'value': ['116.400516', '39.916729']},\n  {'name': '荷花市场', 'value': ['116.398287', '39.94015']},\n  {'name': '南宫御温泉', 'value': ['116.162389', '39.815494']},\n  {'name': '京东大峡谷', 'value': ['117.180659', '40.251256']},\n  {'name': '黑龙潭风景区', 'value': ['116.793737', '40.569355']},\n  {'name': '钟表馆', 'value': ['116.405192', '39.925225']},\n  {'name': '奥林匹克水上公园', 'value': ['116.699695', '40.187846']},\n  {'name': '朝阳公园', 'value': ['116.4891144', '39.9500019']},\n  {'name': '百里山水画廊', 'value': ['116.257788', '40.666026']},\n  {'name': '孔庙和国子监博物馆', 'value': ['116.420343', '39.953111']},\n  {'name': '中央电视塔', 'value': ['116.313595', '39.925494']},\n  {'name': '玉渊潭公园', 'value': ['116.329057', '39.92195']},\n  {'name': '青龙湖公园', 'value': ['116.094874', '39.802592']},\n  {'name': '地坛公园', 'value': ['116.419984', '39.959692']},\n  {'name': '仙居谷', 'value': ['117.244413', '40.594961']},\n  {'name': '陶然亭公园', 'value': ['116.388442', '39.88066']},\n  {'name': '中国紫檀博物馆', 'value': ['116.532527', '39.916834']},\n  {'name': '丫髻山', 'value': ['116.9757113', '40.2798983']},\n  {'name': '南宫旅游景区', 'value': ['116.161143', '39.81265']},\n  {'name': '水关长城', 'value': ['116.044886', '40.343181']},\n  {'name': '首都博物馆', 'value': ['116.349192', '39.912283']},\n  {'name': '北京大观园', 'value': ['116.362822', '39.877081']},\n  {'name': '什刹海', 'value': ['116.391243', '39.948373']},\n  {'name': '龙潭湖公园', 'value': ['116.446425', '39.884624']},\n  {'name': '中国航空博物馆', 'value': ['116.372885', '40.192095']},\n  {'name': '中国人民抗日战争纪念馆', 'value': ['116.232491', '39.857778']},\n  {'name': '北京凤凰岭景区', 'value': ['116.0917633', '40.1119661']},\n  {'name': '西国贸水会', 'value': ['116.3160574', '39.8608448']},\n  {'name': '北京世界葡萄博览园', 'value': ['115.879672', '40.471523']},\n  {'name': '古崖居', 'value': ['115.78223', '40.468621']},\n  {'name': '大运河森林公园', 'value': ['116.748895', '39.882386']},\n  {'name': '北京明城墙遗址公园', 'value': ['116.434388', '39.907202']},\n  {'name': '坡峰岭', 'value': ['115.84427', '39.709779']},\n  {'name': '龙脉温泉', 'value': ['116.406275', '40.187251']},\n  {'name': '张裕爱斐堡', 'value': ['116.90818', '40.382065']},\n  {'name': '北宫国家森林公园', 'value': ['116.127205', '39.868697']},\n  {'name': '紫竹院公园', 'value': ['116.326003', '39.948517']},\n  {'name': '小汤山现代农业科技示范园', 'value': ['116.439621', '40.161189']},\n  {'name': '乐多港卡乐星球', 'value': ['116.196994', '40.241035']},\n  {'name': '八达岭野生动物园', 'value': ['116.001343', '40.359586']},\n  {'name': '北京奥林匹克水上公园欢乐水世界', 'value': ['116.699695', '40.187846']},\n  {'name': '神泉峡风景区', 'value': ['115.98119', '40.053561']},\n  {'name': '爨底下村', 'value': ['115.652612', '40.001593']},\n  {'name': '蟹岛绿色生态度假村', 'value': ['116.554475', '40.025529']},\n  {'name': '水立方', 'value': ['116.396829', '39.999266']},\n  {'name': '大兴世界月季主题园', 'value': ['116.4245864', '39.6795006']},\n  {'name': '八达岭古长城（残长城）', 'value': ['115.979423', '40.356556']},\n  {'name': '北京自然博物馆', 'value': ['116.406249', '39.889596']},\n  {'name': '韩建翠溪谷大美儿童世界', 'value': ['115.98896', '39.777829']},\n  {'name': '北京温榆河阿尔法探险乐园', 'value': ['116.463841', '40.065942']},\n  {'name': '桃源仙谷', 'value': ['116.802999', '40.546673']},\n  {'name': '石花洞月亮山景区', 'value': ['115.960421', '39.803928']},\n  {'name': '大钟寺', 'value': ['116.344605', '39.97492']},\n  {'name': '奇思妙想减压馆', 'value': ['116.428207', '39.904441']},\n  {'name': '九眼楼', 'value': ['116.525318', '40.504274']},\n  {'name': '云梦仙境', 'value': ['116.701279', '40.625502']},\n  {'name': '老北京胡同游', 'value': ['116.391622', '39.940498']},\n  {'name': '兴隆公园', 'value': ['116.5375521', '39.9190445']},\n  {'name': '京西古道', 'value': ['116.0560942', '39.9724643']},\n  {'name': '劳动人民文化宫', 'value': ['116.4061949', '39.9187355']},\n  {'name': '石花洞国家地质公园', 'value': ['115.952749', '39.801789']},\n  {'name': '中国人民革命军事博物馆', 'value': ['116.33021', '39.914968']},\n  {'name': '八大处富斯特索·滑道', 'value': ['116.184351', '39.971196']},\n  {'name': '国家体育馆', 'value': ['116.390254', '39.996578']},\n  {'name': '蓝可可亲子乐园', 'value': ['116.449344', '40.051016']},\n  {'name': '幽岚山·童话森林', 'value': ['115.871266', '39.690576']},\n  {'name': '蓝海亲子乐园', 'value': ['116.113679', '39.684137']},\n  {'name': '云蒙山国家森林公园', 'value': ['116.825298', '40.552686']},\n  {'name': '大觉寺', 'value': ['116.1132892', '40.0586315']},\n  {'name': '詹天佑纪念馆', 'value': ['116.013297', '40.364345']},\n  {'name': '西游王国•西游主题乐园', 'value': ['116.214935', '39.84583']},\n  {'name': '首钢工业遗址公园', 'value': ['116.170035', '39.915904']},\n  {'name': '密云云蒙山风景区', 'value': ['116.824994', '40.552925']},\n  {'name': '熊猫馆', 'value': ['116.3458103', '39.9454806']},\n  {'name': '权品·健康城', 'value': ['116.300417', '40.030023']},\n  {'name': '清凉谷风景区', 'value': ['116.760481', '40.639741']},\n  {'name': '国家植物园北园', 'value': ['116.216186', '40.007561']},\n  {'name': '南宫露营运动乐园', 'value': ['116.149983', '39.804322']},\n  {'name': '玉渡山', 'value': ['115.895804', '40.55826']},\n  {'name': '呀路古热带植物园', 'value': ['116.60049', '39.664878']},\n  {'name': '陶然亭清芷园游泳馆', 'value': ['116.378384', '39.880239']},\n  {'name': '密云玫瑰情园', 'value': ['116.9183473', '40.3582732']},\n  {'name': '北京石门山风景区', 'value': ['116.669378', '40.491447']},\n  {'name': '北普陀影视城', 'value': ['116.460147', '39.741159']},\n  {'name': '朝阳公园恐龙王国历险城', 'value': ['116.489672', '39.945315']},\n  {'name': '梨树沟休闲小镇', 'value': ['117.257046', '40.295044']},\n  {'name': '绿野仙踪郊野乐园', 'value': ['116.106385', '39.847815']},\n  {'name': '特佳游泳馆', 'value': ['116.441423', '39.9635196']},\n  {'name': '小龙门森林公园', 'value': ['115.449392', '39.983942']},\n  {'name': '幽谷神潭', 'value': ['116.6847499', '40.5374714']},\n  {'name': '太平洋海底世界', 'value': ['116.312596', '39.924905']},\n  {'name': '北京大学', 'value': ['116.316833', '39.998877']},\n  {'name': '天开寺', 'value': ['115.902678', '39.623865']},\n  {'name': '青山园景区', 'value': ['116.242965', '40.575654']},\n  {'name': '卢沟桥', 'value': ['116.2287209', '39.8564209']},\n  {'name': '双龙峡自然风景区', 'value': ['115.720747', '39.959169']},\n  {'name': '亮马河国际风情水岸', 'value': ['116.485426', '39.955013']},\n  {'name': '蓝可可亲子乐园（金盏店）', 'value': ['116.588865', '40.006926']},\n  {'name': '北京独角兽星空艺术馆', 'value': ['116.4183881', '39.9222257']},\n  {'name': '冶仙塔', 'value': ['116.873395', '40.407722']},\n  {'name': '游娱联盟-疯狂的麦咭', 'value': ['116.522533', '39.805882']},\n  {'name': '十渡东湖港', 'value': ['115.530782', '39.674008']},\n  {'name': '明皇蜡像宫', 'value': ['116.219262', '40.232339']},\n  {'name': '多福轩', 'value': ['116.393264', '39.943082']},\n  {'name': '未来亲子童话网绳公园（顺义店）', 'value': ['116.55732', '40.134045']},\n  {'name': '中国美术馆', 'value': ['116.415454', '39.931462']},\n  {'name': '皇穹宇', 'value': ['116.419545', '39.884764']},\n  {'name': '北京田义墓博物馆', 'value': ['116.1646647', '39.9411201']},\n  {'name': '南宫五洲植物乐园', 'value': ['116.160942', '39.799936']},\n  {'name': '泡泡玛特城市乐园', 'value': ['116.48709', '39.94872']},\n  {'name': '百望山森林公园', 'value': ['116.262167', '40.036088']},\n  {'name': '祈年殿', 'value': ['116.419288', '39.889922']},\n  {'name': '百花山自然保护区', 'value': ['115.5975277', '39.8401115']},\n  {'name': '中国国家大剧院', 'value': ['116.396261', '39.91123']},\n  {'name': '奥林匹克塔', 'value': ['116.40065', '40.014691']},\n  {'name': '大岭沟猕猴桃谷', 'value': ['116.2314881', '40.375107']},\n  {'name': '妙峰山', 'value': ['116.0325623', '40.0692366']},\n  {'name': '天安门城楼', 'value': ['116.403865', '39.915407']},\n  {'name': '富国海底世界', 'value': ['116.453669', '39.933996']},\n  {'name': '悬空玻璃艺术馆', 'value': ['116.418481', '39.922161']},\n  {'name': '千灵山', 'value': ['116.0921728', '39.8665933']},\n  {'name': '欢乐松鼠谷', 'value': ['117.0984327', '40.5216992']},\n  {'name': '百里山水画廊—乌龙峡谷', 'value': ['116.465452', '40.703776']},\n  {'name': '中国铁道博物馆', 'value': ['116.5227366', '40.0040121']},\n  {'name': '八达岭饭店', 'value': ['116.016665', '40.361947']},\n  {'name': '北京中华民族园', 'value': ['116.3977927', '39.9891863']},\n  {'name': '神路', 'value': ['116.2301799', '40.260807']},\n  {'name': '中国地质博物馆', 'value': ['116.378741', '39.929388']},\n  {'name': '南宫秘林谷物种具乐营', 'value': ['116.160726', '39.799083']},\n  {'name': '御都隆泉', 'value': ['116.328084', '39.768134']},\n  {'name': '毛主席纪念堂', 'value': ['116.404145', '39.908876']},\n  {'name': '大运河绿岛公园', 'value': ['116.748022', '39.887721']},\n  {'name': '烟袋斜街', 'value': ['116.400974', '39.945443']},\n  {'name': '北京失恋博物馆（王府井）', 'value': ['116.418298', '39.922128']},\n  {'name': '十渡誓言玻璃栈道', 'value': ['115.591407', '39.642657']},\n  {'name': '顺义动物星世界', 'value': ['116.552251', '40.141244']},\n  {'name': '《嗨!北京》', 'value': ['116.368633', '39.939609']},\n  {'name': '长陵', 'value': ['116.255634', '40.306283']},\n  {'name': '圣泉山', 'value': ['116.577581', '40.370045']},\n  {'name': '第五季龙水凤港生态农场', 'value': ['116.7303498', '39.7465169']},\n  {'name': '慕田峪长城索道', 'value': ['116.570303', '40.437922']},\n  {'name': '通州运河公园', 'value': ['116.748887', '39.8824']},\n  {'name': '白云观', 'value': ['116.350119', '39.906539']},\n  {'name': '皇家御河游', 'value': ['116.323233', '39.950832']},\n  {'name': '慈宁宫', 'value': ['116.400888', '39.925346']},\n  {'name': '震远镖局', 'value': ['117.283538', '40.659002']},\n  {'name': '南宫苑公园', 'value': ['116.157453', '39.799404']},\n  {'name': '朝阳公园勇敢者游乐园', 'value': ['116.487932', '39.945534']},\n  {'name': '云峰山', 'value': ['116.956189', '40.593058']},\n  {'name': '中和殿', 'value': ['116.403387', '39.924221']},\n  {'name': '古北口长城', 'value': ['117.19779', '40.701459']},\n  {'name': '德云社相声大会广德楼店', 'value': ['116.401415', '39.902301']},\n  {'name': '恭王府大戏楼', 'value': ['116.39922518567', '39.948356762064']},\n  {'name': '通州运河游船', 'value': ['116.693871', '39.913558']},\n  {'name': '国子监', 'value': ['116.419591', '39.953116']},\n  {'name': '古北水镇童玩馆', 'value': ['117.279246', '40.655026']},\n  {'name': '西山国家森林公园', 'value': ['116.2012768', '39.9824685']},\n  {'name': '北京后花园（白虎涧）风景区', 'value': ['116.1050741', '40.1335917']},\n  {'name': '南宫温泉江户汗蒸', 'value': ['116.1598443', '39.8109741']},\n  {'name': '飞越中国', 'value': ['116.216831', '39.919927']},\n  {'name': '美懋蹦床乐园', 'value': ['116.65984', '40.117133']},\n  {'name': '康西草原', 'value': ['115.85681', '40.405549']},\n  {'name': '北度联盟金海湖碧波花园岛度假区', 'value': ['117.336098', '40.173688']},\n  {'name': '龙门涧', 'value': ['115.567102', '40.028529']},\n  {'name': '宋庆龄故居', 'value': ['116.389564', '39.951737']},\n  {'name': '百里山水画廊—滴水壶', 'value': ['116.471173', '40.689476']},\n  {'name': '北京浴汀湾洗浴', 'value': ['116.332043', '39.693678']},\n  {'name': '京城水系皇家御河游', 'value': ['116.351901', '39.947865']},\n  {'name': 'SportsMonster运动萌兽主题公园', 'value': ['116.315917', '39.878128']},\n  {'name': '德云社三里屯剧场', 'value': ['116.459966', '39.937181']},\n  {'name': '北京观复博物馆', 'value': ['116.540404', '40.013243']},\n  {'name': '北京河北村民俗文化体验园', 'value': ['116.735256', '40.137355']},\n  {'name': '纪晓岚故居', 'value': ['116.393561', '39.896319']},\n  {'name': '百里山水画廊—硅化木', 'value': ['116.3993553', '40.7082329']},\n  {'name': '北京温榆河公园', 'value': ['116.471027', '40.081409']},\n  {'name': '古观象台', 'value': ['116.4412372', '39.9135017']},\n  {'name': '回音壁', 'value': ['116.41951', '39.884433']},\n  {'name': '北京上方山国家森林公园', 'value': ['115.83208', '39.680012']},\n  {'name': '亚瑟王国', 'value': ['116.662181', '40.124305']},\n  {'name': '京津冀旅游年卡', 'value': ['116.402631', '39.918539']},\n  {'name': '北京民生现代美术馆', 'value': ['116.49931', '39.994507']},\n  {'name': '红砖美术馆', 'value': ['116.506291', '40.048543']},\n  {'name': '国家速滑馆', 'value': ['116.3841883', '40.0234845']},\n  {'name': '天池峡谷', 'value': ['116.8314901', '40.5577183']},\n  {'name': '钟鼓楼', 'value': ['116.40236', '39.948732']},\n  {'name': '云龙涧', 'value': ['116.792418', '40.494961']},\n  {'name': '日坛公园', 'value': ['116.450536', '39.920931']},\n  {'name': '延禧宫', 'value': ['116.405073', '39.92673']},\n  {'name': '奥森乐仕堡乐园', 'value': ['116.40886', '40.036119']},\n  {'name': '北京颐和园石舫', 'value': ['116.2760811', '40.0043106']},\n  {'name': '古北水镇大酒店', 'value': ['117.27613', '40.650819']},\n  {'name': '南宫蹦床乐园', 'value': ['116.165995', '39.806753']},\n  {'name': '金龙建国温泉酒店温泉区', 'value': ['116.441594', '39.911585']},\n  {'name': '北冰洋义利园区', 'value': ['116.3659789', '39.7799816']},\n  {'name': '双环亭', 'value': ['116.413285', '39.88996']},\n  {'name': '望京楼', 'value': ['117.28531178265', '40.660611610376']},\n  {'name': '皇家御河游船紫御湾码头', 'value': ['116.323237', '39.950809']},\n  {'name': '北京莱恩堡国际酒庄', 'value': ['116.218778', '39.790114']},\n  {'name': '北京欢乐水魔方', 'value': ['116.255865', '39.88854']},\n  {'name': '人民大会堂', 'value': ['116.400238', '39.911394']},\n  {'name': '奥林匹克森林公园', 'value': ['116.3967998', '40.0252314']},\n  {'name': '保和殿', 'value': ['116.403357', '39.924779']},\n  {'name': '永定河自行车运动公园', 'value': ['116.313723', '39.48232']},\n  {'name': '十渡拒马河漂流', 'value': ['115.601201', '39.640744']},\n  {'name': '温都水城', 'value': ['116.370659', '40.104144']},\n  {'name': '人民英雄纪念碑', 'value': ['116.404165', '39.910966']},\n  {'name': '雅曼达嘎楼', 'value': ['116.423187', '39.95484']},\n  {'name': '红螺寺滑道', 'value': ['116.631693', '40.38097']},\n  {'name': '北京龙溪池洗浴', 'value': ['116.644112', '39.879215']},\n  {'name': '西洋楼遗址', 'value': ['116.3191122', '40.0197333']},\n  {'name': '太和门', 'value': ['116.403553', '39.921716']},\n  {'name': '德胜门箭楼', 'value': ['116.387841', '39.961989']},\n  {'name': '中国科技馆新馆巨幕影院', 'value': ['116.406445', '40.01244']},\n  {'name': '圜丘', 'value': ['116.419632', '39.882351']},\n  {'name': '醇亲王府', 'value': ['116.39092', '39.951392']},\n  {'name': '碣石村', 'value': ['115.76539', '40.046341']},\n  {'name': '报国寺', 'value': ['116.366124', '39.89683']},\n  {'name': '老君堂公园', 'value': ['116.527532', '39.839707']},\n  {'name': '北京龙潭公园中心岛剧场', 'value': ['116.446063', '39.885637']},\n  {'name': '北京乐高探索中心', 'value': ['116.602649', '39.930684']},\n  {'name': '天安门端门', 'value': ['116.403822', '39.916794']},\n  {'name': '北京慈善寺', 'value': ['116.1633116', '39.9860992']},\n  {'name': '国家植物园南园', 'value': ['116.2176288', '39.9969668']},\n  {'name': '中国京西皮影非遗园', 'value': ['116.224528', '40.14343']},\n  {'name': '石经山', 'value': ['115.781581', '39.615352']},\n  {'name': '北京民俗博物馆', 'value': ['116.45072', '39.929778']},\n  {'name': '遇见博物馆·北京798馆', 'value': ['116.501157', '39.990209']},\n  {'name': '东方永利宫商务会馆', 'value': ['116.8128727', '40.3592368']},\n  {'name': '1982农场', 'value': ['116.7397626', '39.9701943']},\n  {'name': '乾清宫', 'value': ['116.403275', '39.926469']},\n  {'name': '十三陵林下旅游文化园', 'value': ['116.213892', '40.288752']},\n  {'name': '寻石问宝（朝阳公园店）', 'value': ['116.490148', '39.9458782']},\n  {'name': '裕龙温泉', 'value': ['116.304651', '39.92761']},\n  {'name': '前门箭楼', 'value': ['116.4043715', '39.9057525']},\n  {'name': '城市绿心森林公园', 'value': ['116.731822', '39.882411']},\n  {'name': '凯悦莱清·汤泉', 'value': ['116.1815299', '39.7538716']},\n  {'name': '水立方嬉水乐园', 'value': ['116.39662', '39.998775']},\n  {'name': '九华山庄温泉主题公园', 'value': ['116.42402', '40.186402']},\n  {'name': '冠图家庭运动中心天竺旗舰店', 'value': ['116.583697', '40.071988']},\n  {'name': '北京鹿世界主题园', 'value': ['116.707515', '40.301568']},\n  {'name': '石刻艺术博物馆', 'value': ['116.336751', '39.950594']},\n  {'name': '云瀑沟', 'value': ['116.049047', '40.583903']},\n  {'name': '鑫华池洗浴汗蒸馆', 'value': ['116.3464779', '39.734829']},\n  {'name': '南宫天空城堡', 'value': ['116.15606', '39.814642']},\n  {'name': '红螺浴园', 'value': ['116.639438', '40.319675']},\n  {'name': '丰台体育中心游泳馆', 'value': ['116.2871112', '39.8735237']},\n  {'name': '大岭沟风景区', 'value': ['116.2316522', '40.3759009']},\n  {'name': '尚隐·沙', 'value': ['116.263248', '39.883697']},\n  {'name': '精灵谷', 'value': ['116.787078', '40.601788']},\n  {'name': '凉水河畔壹号会馆', 'value': ['116.586881', '39.809955']},\n  {'name': '南宫温泉水世界', 'value': ['116.159819', '39.812412']},\n  {'name': '童牛影视小镇', 'value': ['116.6184499', '40.2811545']},\n  {'name': '通州博物馆', 'value': ['116.67377229225', '39.914182695288']},\n  {'name': '北京梵高星空艺术馆', 'value': ['116.418247', '39.916613']},\n  {'name': '悦汤泉', 'value': ['116.605637', '39.920983']},\n  {'name': '水云都汤泉', 'value': ['117.11727', '40.1631']},\n  {'name': '北京沐熙汤泉（窦店镇店）', 'value': ['116.0760412', '39.6708471']},\n  {'name': '法原博物馆', 'value': ['116.407706', '39.901275']},\n  {'name': '神乐署', 'value': ['116.411096', '39.885159']},\n  {'name': '蟠龙山长城', 'value': ['117.19779', '40.701459']},\n  {'name': '虎峪', 'value': ['116.113417', '40.331262']},\n  {'name': '北京延庆奥林匹克园区', 'value': ['115.797049', '40.528801']},\n  {'name': '崇文门饭店', 'value': ['116.424089', '39.906659']},\n  {'name': '汇龙洗浴', 'value': ['116.662864', '40.210924']},\n  {'name': '国家动物博物馆', 'value': ['116.3929919', '40.0111959']},\n  {'name': '九洑湾洗浴汗蒸', 'value': ['116.507736', '40.17515']},\n  {'name': '南宫民族养生温泉', 'value': ['116.160066', '39.798862']},\n  {'name': '奇思妙想魔像馆', 'value': ['116.404634', '39.899996']},\n  {'name': '良人归国风体验馆', 'value': ['116.418373', '39.9166']},\n  {'name': '清水泉商务会馆', 'value': ['116.157434', '39.722496']},\n  {'name': '延庆牡丹园', 'value': ['116.072139', '40.471557']},\n  {'name': '北京沐熙汤泉（房山店）', 'value': ['116.0512116', '39.7268513']},\n  {'name': '798艺术区', 'value': ['116.501104', '39.991061']},\n  {'name': '大红门温泉康体娱乐', 'value': ['116.408933', '39.853145']},\n  {'name': '国家典籍博物馆', 'value': ['116.330581', '39.948853']},\n  {'name': '孔庙', 'value': ['116.420854', '39.952772']},\n  {'name': '浩泰冰上运动中心（天通苑店）', 'value': ['116.42217', '40.066097']},\n  {'name': '北京蓝调庄园', 'value': ['116.617844', '39.97179']},\n  {'name': '万泉河洗浴', 'value': ['116.37294', '39.874369']},\n  {'name': '西湖汤泉', 'value': ['116.557358', '39.929207']},\n  {'name': '雾灵西峰', 'value': ['117.368983', '40.640222']},\n  {'name': '北京活的3D博物馆', 'value': ['116.507681', '39.99011']},\n  {'name': '奇思妙想减压博物馆', 'value': ['116.4182003', '39.9224437']},\n  {'name': '濂泉响谷', 'value': ['116.581851', '40.501603']},\n  {'name': '津泉浴池', 'value': ['116.336928', '39.739403']},\n  {'name': '北京鑫港湾水汇', 'value': ['115.993127', '39.6976592']},\n  {'name': '北京沐熙汤泉（通州店）', 'value': ['116.5517553', '39.7430523']},\n  {'name': '丰益桥聚尚汤泉（丰台店）', 'value': ['116.304805', '39.862602']},\n  {'name': '北京沐晏汤泉', 'value': ['116.52921', '39.90855']},\n  {'name': '南宫农耕文化体验园', 'value': ['116.165311', '39.805401']},\n  {'name': '大美儿童世界·奥林匹克水上公园园区', 'value': ['116.702079', '40.183178']},\n  {'name': '军都山度假区', 'value': ['116.3302638', '40.2354511']},\n  {'name': '北京曲水兰亭水疗SPA', 'value': ['116.5118695', '39.9112184']},\n  {'name': '北京后花园', 'value': ['116.1051292', '40.1335946']},\n  {'name': '宰牲亭', 'value': ['116.4221994', '39.8836708']},\n  {'name': '七星石', 'value': ['116.4225331', '39.8892794']},\n  {'name': '青龙湖水上乐园', 'value': ['116.0952112', '39.8025927']},\n  {'name': '响水湖长城旅游风景区', 'value': ['116.495287', '40.472841']},\n  {'name': '前门大街', 'value': ['116.40452', '39.899651']},\n  {'name': '十七孔桥', 'value': ['116.283926', '39.997']},\n  {'name': '南海子公园', 'value': ['116.4756104', '39.7794827']},\n  {'name': '蜜蜂大世界', 'value': ['117.072686', '40.503796']},\n  {'name': '南池子美术馆', 'value': ['116.409785', '39.919969']},\n  {'name': '北京老爷车博物馆', 'value': ['116.684891', '40.305098']},\n  {'name': '中国第四纪冰川遗迹陈列馆', 'value': ['116.168305', '39.944034']},\n  {'name': '喇叭沟原始森林公园', 'value': ['116.495711', '40.965737']},\n  {'name': '清华大学', 'value': ['116.333374', '40.009645']},\n  {'name': '佛香阁', 'value': ['116.280371', '40.005295']},\n  {'name': '德云社三庆园剧场', 'value': ['116.4032358', '39.9021837']},\n  {'name': '考拉大冒险儿童主题乐园', 'value': ['116.7376684', '40.2098568']},\n  {'name': '平谷桃花海', 'value': ['117.177294', '40.260807']},\n  {'name': '黄花城高山漂流', 'value': ['116.300063', '40.418453']},\n  {'name': '小武基体育馆游泳中心', 'value': ['116.497889', '39.870051']},\n  {'name': '圆明园拾光买卖街', 'value': ['116.314441', '40.017379']},\n  {'name': '昆明湖', 'value': ['116.278314', '39.999894']},\n  {'name': '清晏舫', 'value': ['116.2760826', '40.0043068']},\n  {'name': '嘉德艺术中心', 'value': ['116.416887', '39.9300966']},\n  {'name': '杜威中心', 'value': ['116.489438', '39.892118']},\n  {'name': '长春宫', 'value': ['116.401512', '39.92701']},\n  {'name': '和园景逸温泉', 'value': ['116.493526', '40.091497']},\n  {'name': '北京启晟水汇', 'value': ['116.0776791', '39.6526342']},\n  {'name': 'IOMA爱马思艺术中心', 'value': ['116.500277', '39.991742']},\n  {'name': '木木美术馆', 'value': ['116.501742', '39.992246']},\n  {'name': '皇极殿', 'value': ['116.406713', '39.926308']},\n  {'name': '美豪汤泉', 'value': ['116.277635', '40.071663']},\n  {'name': '光科技馆', 'value': ['116.28323', '40.00944']},\n  {'name': '天池乐活汤城市温泉汗蒸SPA馆', 'value': ['115.952799', '39.736633']},\n  {'name': '文昌院', 'value': ['116.287318', '40.003234']},\n  {'name': '天池乐活汤泉', 'value': ['115.953069', '39.736836']},\n  {'name': '静之湖汤泉', 'value': ['116.447701', '40.247625']},\n  {'name': '紫谷伊甸园', 'value': ['116.266211', '39.816103']},\n  {'name': '潭柘秘境生态路野营地', 'value': ['116.018386', '39.920478']},\n  {'name': '长安街', 'value': ['116.40209', '39.913999']},\n  {'name': '御花园', 'value': ['116.403161', '39.927608']},\n  {'name': '紫禁城角楼', 'value': ['116.407488', '39.9288456']},\n  {'name': '神堂峪', 'value': ['116.61996', '40.445536']},\n  {'name': '尤伦斯当代艺术中心', 'value': ['116.501458', '39.99022']},\n  {'name': '太庙', 'value': ['116.399492', '39.908601']},\n  {'name': '白塔寺', 'value': ['116.369903', '39.930757']},\n  {'name': '十渡蹦极俱乐部', 'value': ['115.60299', '39.640303']},\n  {'name': '水裹·汤泉生活', 'value': ['116.514624', '39.912046']},\n  {'name': '香山饭店', 'value': ['116.200584', '39.998653']},\n  {'name': '德云社（广德楼店）', 'value': ['116.401443', '39.902283']},\n  {'name': '西山温泉', 'value': ['116.256801', '40.073432']},\n  {'name': '西游王国•西游萌宠空间', 'value': ['116.215031', '39.845569']},\n  {'name': '炎黄艺术馆', 'value': ['116.41515', '40.002016']},\n  {'name': '中国非遗馆 (中国工美馆)', 'value': ['116.404125', '40.009944']},\n  {'name': '国家图书馆', 'value': ['116.3298939', '39.9496889']},\n  {'name': '太和殿', 'value': ['116.403432', '39.923657']},\n  {'name': '德云社<北京相声大会>湖广会馆', 'value': ['116.390324', '39.894989']},\n  {'name': '朝阳公园勇敢者乐园', 'value': ['116.487932', '39.945534']},\n  {'name': '古北水镇天然温泉', 'value': ['117.2842402', '40.6610641']},\n  {'name': '尚水泉汤泉汗蒸馆', 'value': ['116.667465', '40.205285']},\n  {'name': '密云天门山', 'value': ['116.794476', '40.598044']},\n  {'name': '北京新华联丽景温泉', 'value': ['116.7655935', '40.1294867']},\n  {'name': '十渡七彩玻璃漂流', 'value': ['115.530778', '39.674025']},\n  {'name': '东南角楼', 'value': ['116.440374', '39.90752']},\n  {'name': '龙潭中湖公园', 'value': ['116.4397208', '39.8828173']},\n  {'name': '妫河森林公园', 'value': ['115.9114616', '40.4488413']},\n  {'name': '东龙十八潭自然风景区', 'value': ['117.2871966', '40.5892563']},\n  {'name': '鸟巢北京会展中心4D全息演唱会馆', 'value': ['116.403959', '39.998964']},\n  {'name': '嗨空间蹦床公园 HIGH ZONE', 'value': ['116.346688', '39.848816']},\n  {'name': '灵水村', 'value': ['115.74066', '40.008129']},\n  {'name': '留民营生态农场', 'value': ['116.5809825', '39.699791']},\n  {'name': '海坨山', 'value': ['115.8266765', '40.565448']},\n  {'name': '尚隐·泉都市生活馆', 'value': ['116.263248', '39.883697']},\n  {'name': '北京欢乐谷金面王朝', 'value': ['116.5054194', '39.8732414']},\n  {'name': '莱恩堡城市营地', 'value': ['116.2165128', '39.7922628']},\n  {'name': '古北口文化文物旅游区', 'value': ['117.172539', '40.689864']},\n  {'name': '王府井商业街', 'value': ['116.418038', '39.91979']},\n  {'name': '百花谷', 'value': ['115.566764', '39.861951']},\n  {'name': '龙熙温泉', 'value': ['116.3086', '39.630682']},\n  {'name': '珊瑚岛大冒险探险乐园', 'value': ['116.2921031', '39.8182409']},\n  {'name': '北京邑仕庄园国际酒庄', 'value': ['117.055248', '40.492133']},\n  {'name': '坤宁宫', 'value': ['116.403248', '39.927103']},\n  {'name': '青年湖公园', 'value': ['116.408933', '39.961277']},\n  {'name': '万达宝贝王（北京通州店）', 'value': ['116.649033', '39.912078']},\n  {'name': '万福阁', 'value': ['116.422965', '39.952205']},\n  {'name': '【直升机】北京八达岭长城空中飞行体验游', 'value': ['115.952651', '40.383432']},\n  {'name': '八达岭直升机空中游览', 'value': ['115.958983', '40.378548']},\n  {'name': '北京奈尔宝家庭中心（爱琴海店）', 'value': ['116.428228', '39.82567']},\n  {'name': '前门华韵泰山皮影体验馆', 'value': ['116.4047398', '39.900436']},\n  {'name': '汉汤泉', 'value': ['116.570747', '40.012774']},\n  {'name': '北京八达岭飞行体验', 'value': ['115.953368', '40.382773']},\n  {'name': '北京尚荟汤泉', 'value': ['116.4653967', '39.8775015']},\n  {'name': '妫水河森林公园', 'value': ['115.968053', '40.462239']},\n  {'name': '九华山庄', 'value': ['116.42402', '40.186402']},\n  {'name': '九谷口风景区', 'value': ['116.668525', '40.450379']},\n  {'name': '人间花海', 'value': ['117.210105', '40.5773333']},\n  {'name': '北京科技大学', 'value': ['116.3661', '39.99582']},\n  {'name': '南锣鼓巷', 'value': ['116.4095', '39.943166']},\n  {'name': '密云水库', 'value': ['116.920432', '40.523288']},\n  {'name': '中国宋庆龄青少年科技文化交流中心', 'value': ['116.32223', '39.917764']},\n  {'name': '幽岚山卡丁车俱乐部', 'value': ['115.876058', '39.691613']},\n  {'name': '春晖园温泉度假村', 'value': ['116.497568', '40.136604']},\n  {'name': '曼联梦剧场', 'value': ['116.401072', '39.903746']},\n  {'name': '神玉艺术馆', 'value': ['116.396979', '39.975239']},\n  {'name': '世贸天阶', 'value': ['116.457351', '39.922145']},\n  {'name': '永宁古城', 'value': ['116.172984', '40.5292']},\n  {'name': '中国古动物馆', 'value': ['116.340639', '39.943187']},\n  {'name': '八达岭国家森林公园', 'value': ['116.035858', '40.350587']},\n  {'name': '灵山', 'value': ['115.508638', '40.045961']},\n  {'name': '艺麓园', 'value': ['116.154216', '40.248833']},\n  {'name': '北京林业大学', 'value': ['116.352044', '40.006636']},\n  {'name': '北京二锅头博物馆', 'value': ['116.671525', '40.332082']},\n  {'name': '团结湖公园', 'value': ['116.471259', '39.931471']},\n  {'name': '首钢园群明湖缦野游船', 'value': ['116.156435', '39.9139306']},\n  {'name': '深逸水疗汇', 'value': ['116.254403', '40.208198']},\n  {'name': '奥林匹克森林公园-北园', 'value': ['116.398874', '40.034046']},\n  {'name': '中华世纪坛艺术馆', 'value': ['116.32832', '39.917091']},\n  {'name': '司马小烧酒坊', 'value': ['117.284632', '40.661046']},\n  {'name': '北京乐多港万豪酒店汤乐宫温泉', 'value': ['116.1955909', '40.2387833']},\n  {'name': '北京乔波冰雪世界', 'value': ['116.667894', '40.206053']},\n  {'name': '清华大学艺术博物馆', 'value': ['116.342234', '40.007638']},\n  {'name': '东方威尼斯国际温泉酒店', 'value': ['116.317583', '39.879706']},\n  {'name': '清华大学新清华学堂', 'value': ['116.34251506755', '40.012769123006']},\n  {'name': '北京理工大学', 'value': ['116.32813226005', '39.965830391469']},\n  {'name': '温都水城.水梦奇缘', 'value': ['116.377085', '40.110253']},\n  {'name': '北京师范大学', 'value': ['116.372141', '39.967345']},\n  {'name': '水境汤泉', 'value': ['116.258707', '39.894946']},\n  {'name': '万寿寺', 'value': ['116.3186001', '39.9533653']},\n  {'name': '圆明园·720穿越飞船', 'value': ['116.3154702', '40.0126653']},\n  {'name': '张坊古战道', 'value': ['115.720894', '39.576967']},\n  {'name': '和园景逸大酒店朗月温泉', 'value': ['116.493526', '40.091497']},\n  {'name': '东棉花胡同', 'value': ['116.412399', '39.942015']},\n  {'name': '古北水镇司马台新村山水城', 'value': ['117.170492', '40.697861']},\n  {'name': '蓝色港湾', 'value': ['116.481404', '39.955013']},\n  {'name': '白瀑寺', 'value': ['115.927283', '40.124144']},\n  {'name': '苏州街', 'value': ['116.2806', '40.008137']},\n  {'name': '中国电影博物馆', 'value': ['116.526921', '40.0028003']},\n  {'name': '法海寺', 'value': ['116.1659216', '39.9478741']},\n  {'name': '亮剑真人CS拓展（南宫体育公园店）', 'value': ['116.162173', '39.780609']},\n  {'name': '北京杜莎夫人蜡像馆', 'value': ['116.404671', '39.903663']},\n  {'name': '啵乐乐儿童主题乐园', 'value': ['116.315024', '39.877868']},\n  {'name': '加速北京跳伞俱乐部', 'value': ['116.997952', '40.04814']},\n  {'name': '名华四季国际温泉会所', 'value': ['116.231271', '39.9616814']},\n  {'name': '北京公共安全体验馆', 'value': ['116.652633', '40.066625']},\n  {'name': '灵慧山', 'value': ['116.591396', '40.401874']},\n  {'name': '中华世纪坛', 'value': ['116.327863', '39.917371']},\n  {'name': '万达宝贝王(北京槐房店)', 'value': ['116.373426', '39.820889']},\n  {'name': '北京大戚收音机电影机博物馆', 'value': ['116.731702', '39.967359']},\n  {'name': '李大钊故居', 'value': ['116.372449', '39.910656']},\n  {'name': '德云社<北京相声大会>天桥会馆', 'value': ['116.404395', '39.890323']},\n  {'name': '数字敦煌·丝绸之路上的敦煌', 'value': ['116.592528', '40.11925']},\n  {'name': '西单商业街', 'value': ['116.380702', '39.914446']},\n  {'name': '银锭桥', 'value': ['116.3905', '39.939416']},\n  {'name': '后海', 'value': ['116.388809', '39.948395']},\n  {'name': '八达岭熊乐园', 'value': ['116.02580532913', '40.361249914314']},\n  {'name': 'clubmed joyview 北京延庆度假村(辉煌度假区)',\n   'value': ['115.82733', '40.467864']},\n  {'name': '中国人民大学', 'value': ['116.319769', '39.976546']},\n  {'name': '金隅凤山温泉', 'value': ['116.286965', '40.256188']},\n  {'name': '嘉安卡丁车俱乐部', 'value': ['116.37993', '39.836312']},\n  {'name': '紫云台香草园', 'value': ['116.0957684', '40.0909721']},\n  {'name': '城上温泉馆', 'value': ['117.28264', '40.660185']},\n  {'name': 'teamLab无相艺术空间', 'value': ['116.524819', '39.930772']},\n  {'name': '健乐苑商务会馆', 'value': ['116.195771', '39.919737']},\n  {'name': '莲花山森林公园', 'value': ['117.9021664', '36.5249673']},\n  {'name': '爱上水索道滑水', 'value': ['116.698912', '40.183815']},\n  {'name': '宝燕乐园(大红门店)', 'value': ['116.394945', '39.8400147']},\n  {'name': '北京爱沐汤泉', 'value': ['116.247003', '39.901324']},\n  {'name': '北方温泉', 'value': ['116.168788', '39.749096']},\n  {'name': '凤凰中心', 'value': ['116.480337', '39.940342']},\n  {'name': '北京寰羽飞行基地', 'value': ['115.850186', '39.623724']},\n  {'name': '仁寿殿', 'value': ['116.286464', '40.004104']},\n  {'name': '红剧场', 'value': ['116.438603', '39.891659']},\n  {'name': '朝阳公园WhaleSports水上运动俱乐部', 'value': ['116.485539', '39.953456']},\n  {'name': '稻香湖景温泉', 'value': ['116.1899225', '40.0978819']},\n  {'name': '天云山', 'value': ['117.263277', '40.320184']},\n  {'name': '白云峡', 'value': ['116.820412', '40.620371']},\n  {'name': '北京Meland Club(芳圆里ID MALL店)', 'value': ['116.494423', '39.896949']},\n  {'name': '行宫国际酒店温泉', 'value': ['116.514653', '39.938651']},\n  {'name': '老舍茶馆', 'value': ['116.399659', '39.906052']},\n  {'name': '鹅和鸭农庄', 'value': ['116.564865', '40.337629']},\n  {'name': '慕田峪长城岁月沉浸式光影体验馆', 'value': ['116.569713', '40.437307']},\n  {'name': '东方普罗旺斯薰衣草庄园', 'value': ['116.626026', '40.345672']},\n  {'name': '花仙子万花园', 'value': ['116.698458', '39.713979']},\n  {'name': '北京延庆奇巴布乐园', 'value': ['115.971134', '40.448113']},\n  {'name': '百泉山', 'value': ['116.668266', '40.500437']},\n  {'name': '凤凰台', 'value': ['117.16994605033', '40.243548783648']},\n  {'name': '潘家园旧货市场', 'value': ['116.462896', '39.880564']},\n  {'name': '八旗会馆', 'value': ['117.284868', '40.659311']},\n  {'name': '杨无敌祠', 'value': ['117.280338', '40.656621']},\n  {'name': '北京元代谷蒙古部落', 'value': ['115.982417', '40.410099']},\n  {'name': '北京百年世界老电话博物馆', 'value': ['116.7081203', '39.9519388']},\n  {'name': '北京励志堂科举匾额博物馆', 'value': ['116.5472483', '39.904438']},\n  {'name': '北京药王谷风景区', 'value': ['115.855635', '39.719446']},\n  {'name': '簋街', 'value': ['116.441207', '39.948524']},\n  {'name': '国家会议中心', 'value': ['116.396466', '40.006295']},\n  {'name': '雾灵山', 'value': ['117.368957', '40.640213']},\n  {'name': '北京刘老根大舞台', 'value': ['116.406961', '39.899788']},\n  {'name': '京彩瓷博物馆', 'value': ['116.354941', '39.8881']},\n  {'name': 'Meland Club(北京银座和谐广场)', 'value': ['116.3035396', '39.888591']},\n  {'name': '古陶文明博物馆', 'value': ['116.363826', '39.87908']},\n  {'name': '汉拿山汤泉国际酒店（亚运村店）', 'value': ['116.431524', '40.004325']},\n  {'name': '北京艺术博物馆', 'value': ['116.317868', '39.952595']},\n  {'name': '永顺染坊', 'value': ['117.278446', '40.654349']},\n  {'name': '北京展览馆', 'value': ['116.350668', '39.946119']},\n  {'name': '萌溪儿童俱乐部', 'value': ['116.485001', '39.949738']},\n  {'name': '金隅八达岭沐沄温泉', 'value': ['115.981472', '40.482131']},\n  {'name': '古北之光温泉', 'value': ['117.281931', '40.659378']},\n  {'name': '警察博物馆', 'value': ['116.411541', '39.908366']},\n  {'name': '北京金融街丽思卡尔顿酒店', 'value': ['116.369719', '39.921087']},\n  {'name': '天葡庄园（延庆）', 'value': ['116.022434', '40.495822']},\n  {'name': '猎人国际真人CS', 'value': ['116.205101', '40.112315']},\n  {'name': '三里屯', 'value': ['116.460972', '39.940723']},\n  {'name': '十渡人家', 'value': ['115.598139', '39.637054']},\n  {'name': '焦庄户地道战遗址', 'value': ['116.876554', '40.240192']},\n  {'name': '圣泉山观音寺', 'value': ['116.584915', '40.36952']},\n  {'name': '东极仙谷自然风景区', 'value': ['117.503579', '40.651883']},\n  {'name': '乐仕堡儿童素质教育基地', 'value': ['116.408897', '40.035937']},\n  {'name': '北京百姓浴都', 'value': ['116.3042161', '39.7906691']},\n  {'name': '妙峰山风景区', 'value': ['116.0325623', '40.0692366']},\n  {'name': '莲花山景区', 'value': ['115.725574', '39.59925']},\n  {'name': '乐仕堡儿童运动拓展中心（万柳华联店）', 'value': ['116.301748', '39.979194']},\n  {'name': '翠明庄', 'value': ['116.412879', '39.92102']},\n  {'name': '华侨大厦', 'value': ['116.42448806243', '39.93612265697']},\n  {'name': '天香阁汤泉', 'value': ['116.214562', '39.833978']},\n  {'name': '昊天公园', 'value': ['116.1608172', '39.7399559']},\n  {'name': '北京大唐水汇', 'value': ['116.2374507', '40.2294882']},\n  {'name': '北京(通州)大运河文化旅游景区', 'value': ['116.6740798', '39.9201255']},\n  {'name': '西湖浴都（双平西街店）', 'value': ['116.664196', '40.105679']},\n  {'name': '北京潞芳园洗浴', 'value': ['116.7002628', '39.9374831']},\n  {'name': '金晟汤泉', 'value': ['116.167113', '39.767469']},\n  {'name': '韩村河', 'value': ['115.967974', '39.605363']},\n  {'name': '西游王国-西游飞车', 'value': ['116.215294', '39.845611']},\n  {'name': '科苑宾馆·游泳馆', 'value': ['116.363643', '39.98476']},\n  {'name': '西湖浴都', 'value': ['116.649175', '39.924352']},\n  {'name': '鑫港湾水汇', 'value': ['115.993128', '39.697654']},\n  {'name': '唐人坊人偶艺术博物馆', 'value': ['116.746975', '39.839378']},\n  {'name': '三影堂摄影艺术中心', 'value': ['116.5144232', '40.0079908']},\n  {'name': '台湖里休闲洗浴', 'value': ['116.630045', '39.846861']},\n  {'name': '北京龙顺成京作非遗博物馆', 'value': ['116.407658', '39.874695']},\n  {'name': '浩泰冰上运动中心（奥森店）', 'value': ['116.4143209', '40.0384317']},\n  {'name': '十渡山地滑车', 'value': ['115.613522', '39.647039']},\n  {'name': '德和园', 'value': ['116.286347', '40.004532']},\n  {'name': '道酷迈儿童卡丁车(乐多港万达店)', 'value': ['116.1909888', '40.2304334']},\n  {'name': '良子健身（顺义店）', 'value': ['116.6554066', '40.1333419']},\n  {'name': '蜜蜂生态科普馆', 'value': ['117.117825', '40.610462']},\n  {'name': '不可思议运动街区(丽泽天街店)', 'value': ['116.3344118', '39.8664336']},\n  {'name': '崇文门', 'value': ['116.424439', '39.906953']},\n  {'name': '水库假日汤泉', 'value': ['116.457351', '40.027707']},\n  {'name': '清凉谷千尺珍珠瀑', 'value': ['116.725866', '40.622237']},\n  {'name': '声音艺术博物馆', 'value': ['116.4133837', '39.9109245']},\n  {'name': '卫泉冰雪《冰天雪地》卡乐星球店', 'value': ['116.196994', '40.241035']},\n  {'name': '广济寺', 'value': ['116.378703', '39.930786']},\n  {'name': '走进圆明园之逛园子剧景游', 'value': ['116.3115481', '40.0025026']},\n  {'name': '北京水悦汤泉生活馆', 'value': ['116.526637', '39.951501']},\n  {'name': '长城直升机飞行体验中心', 'value': ['115.953369', '40.382773']},\n  {'name': '北京飞人滑翔伞飞行体验基地', 'value': ['115.72546', '39.591173']},\n  {'name': '八达岭精功通航飞行体验', 'value': ['115.953053', '40.383301']},\n  {'name': 'NICE森林假日营地', 'value': ['116.328626', '39.488901']},\n  {'name': '秀峰寺', 'value': ['116.10759', '40.070647']},\n  {'name': '天竺黄花梨艺术馆', 'value': ['116.587416', '40.069236']},\n  {'name': '钟楼', 'value': ['118.597534', '24.918171']},\n  {'name': '汤泉良子（首钢园店）', 'value': ['116.1631747', '39.9227549']},\n  {'name': '北大红楼', 'value': ['116.411699', '39.931001']},\n  {'name': '爱伴family乐园(奥森店)', 'value': ['116.3995996', '40.010831']},\n  {'name': '缦纯轰趴馆', 'value': ['116.514349', '40.000934']},\n  {'name': '阿比特室内滑雪俱乐部', 'value': ['116.203625', '39.83141']},\n  {'name': '槐新公园', 'value': ['116.367421', '39.830988']},\n  {'name': '《梦华长城》演出', 'value': ['115.9693333', '40.4483961']},\n  {'name': '植物染色艺术馆', 'value': ['116.4911156', '40.405392']},\n  {'name': '皇城御窑金砖博物馆', 'value': ['116.885029', '39.7183741']},\n  {'name': '寰羽飞行滑翔伞俱乐部', 'value': ['115.8504039', '39.6237253']},\n  {'name': '深滤空间SaltSpace洞穴盐疗（银河SOHO店）', 'value': ['116.440366', '39.927038']},\n  {'name': '亮剑盟真人cs拓展 (大兴北普陀影视城店)', 'value': ['116.458336', '39.741574']},\n  {'name': '白羊沟', 'value': ['116.01716224571', '40.207473616187']}]}"
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_point = df[(df['longitude'] > 0) & (df['latitude'] > 0)]\n",
    "{\n",
    "    'data': [{'name': i[0], 'value': i[1].split(',')} for i in df_point[['name', 'point']].values.tolist()]\n",
    "}"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T08:31:03.015188300Z",
     "start_time": "2024-05-31T08:31:02.944239600Z"
    }
   },
   "id": "c566076dbc59dd6f"
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "outputs": [],
   "source": [
    "import jieba\n",
    "import jieba.analyse\n",
    "\n",
    "word_cut = \" \".join(\n",
    "    [\" \".join(jieba.lcut(i)).replace('、', '').replace('。', '').replace('，', '').replace('\\r\\n', '') for i in\n",
    "     df[df['intro'] != '无']['intro'].values.tolist()])\n",
    "word_counts = jieba.analyse.extract_tags(word_cut, topK=20, withWeight=True)"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T09:13:54.638129800Z",
     "start_time": "2024-05-31T09:13:54.544020500Z"
    }
   },
   "id": "3fb06184a7998c0"
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "outputs": [
    {
     "data": {
      "text/plain": "[{'name': '北京', 'value': 0.07821281042692028},\n {'name': '休闲', 'value': 0.05589596280403985},\n {'name': '汤泉', 'value': 0.04877238170187954},\n {'name': '乐园', 'value': 0.048343441385133606},\n {'name': '北京市', 'value': 0.047012335182255435},\n {'name': '位于', 'value': 0.04498270635498188},\n {'name': '温泉', 'value': 0.042706765316793474},\n {'name': '体验', 'value': 0.042079817288666214},\n {'name': '洗浴', 'value': 0.040495648632826085},\n {'name': '观赏', 'value': 0.0348966558289221},\n {'name': '娱乐', 'value': 0.03418500115788044},\n {'name': '亲子', 'value': 0.032536974839402176},\n {'name': '一体', 'value': 0.03006976363789402},\n {'name': '养生', 'value': 0.029977934228057064},\n {'name': '坐落于', 'value': 0.026984743854402173},\n {'name': '建筑', 'value': 0.02501742011093524},\n {'name': '公园', 'value': 0.023977792715692937},\n {'name': '儿童', 'value': 0.02311126451589674},\n {'name': '一家', 'value': 0.02279944983158967},\n {'name': '主题', 'value': 0.022465153799130434}]"
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[{'name': i[0], 'value': i[1]} for i in word_counts]"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T09:14:58.064499200Z",
     "start_time": "2024-05-31T09:14:58.058145800Z"
    }
   },
   "id": "48a26b2639ef561"
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "outputs": [
    {
     "data": {
      "text/plain": "            id      name  score star  sale_count  \\\n0   1497883331   北京环球度假区    0.0    无       16621   \n1    777857128     八达岭长城    4.1   5A       12285   \n2   4268080051       颐和园    4.1   5A       10140   \n3   1699488273   北京野生动物园    3.5   4A        9962   \n4   1053903287      天坛公园    4.0   5A        8661   \n5   3070792170       恭王府    3.7   5A        6864   \n6    989946426     故宫博物院    5.0   5A        5760   \n7   1577458228       珍宝馆    0.0    无        7433   \n8   1427399043       圆明园    3.8   5A        5564   \n9   1987315843     慕田峪长城    3.5   5A        4673   \n10  2549325765     北京动物园    3.6   4A        3893   \n11    89108430        鸟巢    4.2    无        4540   \n12  2131323089      北海公园    3.8   4A        2951   \n13  3318389804   中国国家博物馆    3.5    无        3716   \n14  2269763832      明十三陵    3.6   5A        2757   \n15  3770579544      景山公园    3.7   4A        2829   \n16  4194325354     天安门广场    5.0    无        3234   \n17  1465994645        午门    0.0    无        2771   \n18  3389244336     北京海洋馆    3.5   4A        1690   \n19  2769149828     北京欢乐谷    3.6   4A        1900   \n20  1433128305      古北水镇    0.0    无        2471   \n21  3125362020       雍和宫    3.8    无        2258   \n23   330194371      升旗仪式    0.0    无        2397   \n26  2732618148   中国科学技术馆    0.0    无        2271   \n27  1504293946    北京世界公园    3.5   4A        1076   \n32  3317086974        定陵    3.6    无        2117   \n60   547084149       钟表馆    0.0    无        1526   \n94  2463434580  八达岭野生动物园    3.5    无        1020   \n\n                                                intro  \\\n0                                           大片世界，在此成真   \n1                                             不到长城非好汉   \n2                                         走入清朝皇帝的皇家园林   \n3                                           近距离观赏野生动物   \n4                                         明清时期皇帝祭天的地方   \n5                                         旧时清朝大臣和珅的府邸   \n6                                        穿越明清两朝的皇家宫殿群   \n7                                           乾隆慈禧曾居住在这   \n8                                         毁于战火的清代皇家园林   \n9                                           看万里长城山河壮丽   \n10                                          观赏众多的珍稀动物   \n11                                          新北京的标志性建筑   \n12                                        白塔湖水相依的皇家园林   \n13                                          穿越千年看中华珍宝   \n14                                       埋葬十三位明朝皇帝的陵园   \n15                                        明朝崇祯皇帝自缢的地方   \n16                                           祖国的象征与心脏   \n17                                             紫禁城的正门   \n18                                          观赏上千种水族动物   \n19                                        玩耍众多刺激的游乐项目   \n20                                        在长城脚下泡温泉爬长城   \n21                                       生活过雍正与乾隆两位皇帝   \n23  在天安门广场看升、降旗仪式，是游览天安门广场不可或缺的项目。每天全国各地的游客都会来此观看，...   \n26                                           小朋友的科学乐园   \n27                                       汇集各国知名建筑的微缩版   \n32                                        明代万历皇帝的大型陵墓   \n60                                         原皇帝祭祀祖先的宫殿   \n94                                          近距离观赏野生动物   \n\n                                address  price  discount  \\\n0                         北京市通州区北京环球度假区  505.0       8.6   \n1                     北京市延庆区G6京藏高速58号出口   39.5       3.9   \n2                        北京市海淀区新建宫门路19号   30.0      10.0   \n3                     北京市大兴区榆垡镇永定河畔的万亩林  145.0       9.6   \n4                          北京市东城区天坛路甲1号   15.0       7.5   \n5                         北京市西城区前海西街17号   40.0      10.0   \n6                          北京市东城区景山前街4号   80.0      10.0   \n7                            故宫博物院宁寿宫内    35.0       3.9   \n8                         北京市海淀区清华西路28号   64.0      10.0   \n9                         北京市怀柔区渤海镇慕田峪村   60.0      10.0   \n10                        北京市西直门外大街137号   15.0      10.0   \n11                      北京市朝阳区国家体育场南路1号   94.0       9.4   \n12                          北京市西城区文津街1号    9.3       9.3   \n13                 北京市东城区东长安街16号天安门广场东侧  138.0      10.0   \n14                        北京市昌平区十三陵镇昌赤路   30.0      10.0   \n15                       北京市西城区景山前街景山公园    6.0      10.0   \n16                 北京市东城区长安街（天安门和正阳门之间）   17.0       1.7   \n17                         北京市东城区故宫博物院内   38.0      10.0   \n18                      北京市海淀区高粱桥斜街乙18号  158.0      10.0   \n19   北京市朝阳区东四环小武基北路(欢乐谷景区地铁站B东北口步行170米)  299.0      10.0   \n20  北京市密云区古北口镇司马台村古北水镇 （京承高速24号司马台长城出口）  140.0       8.7   \n21                       北京市东城区雍和宫大街12号   27.0       9.0   \n23                           北京市天安门广场南端   28.0       4.8   \n26                         北京市朝阳区北辰东路5号   30.0       6.0   \n27                      北京市丰台区花乡丰葆路158号   95.0       9.5   \n32           北京市昌平区环陵路北京十三陵风景区内盛得剧场西60米   90.0       9.0   \n60                       景山前街4号故宫博物院奉先殿   38.0       6.5   \n94                     北京市延庆区八达岭镇八达岭旅游区   85.0       9.4   \n\n                     point   longitude   latitude  \n0       116.68782,39.86099  116.687820  39.860990  \n1     116.024067,40.362639  116.024067  40.362639  \n2   116.2802339,40.0088172  116.280234  40.008817  \n3     116.340954,39.502139  116.340954  39.502139  \n4     116.419289,39.889918  116.419289  39.889918  \n5     116.392599,39.943381  116.392599  39.943381  \n6     116.403414,39.924091  116.403414  39.924091  \n7     116.406346,39.925979  116.406346  39.925979  \n8     116.309736,40.016191  116.309736  40.016191  \n9     116.575896,40.440146  116.575896  40.440146  \n10    116.342331,39.947726  116.342331  39.947726  \n11    116.402845,39.999285  116.402845  39.999285  \n12    116.395006,39.934167  116.395006  39.934167  \n13    116.408018,39.911449  116.408018  39.911449  \n14    116.231846,40.263544  116.231846  40.263544  \n15    116.402966,39.932136  116.402966  39.932136  \n16    116.404091,39.910095  116.404091  39.910095  \n17    116.403705,39.920105  116.403705  39.920105  \n18    116.347445,39.950257  116.347445  39.950257  \n19    116.501309,39.873868  116.501309  39.873868  \n20    117.284632,40.661046  117.284632  40.661046  \n21    116.423776,39.953314  116.423776  39.953314  \n23    116.403931,39.913288  116.403931  39.913288  \n26    116.404938,40.012333  116.404938  40.012333  \n27     116.293772,39.81671  116.293772  39.816710  \n32     116.232421,40.30048  116.232421  40.300480  \n60    116.405192,39.925225  116.405192  39.925225  \n94    116.001343,40.359586  116.001343  40.359586  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>name</th>\n      <th>score</th>\n      <th>star</th>\n      <th>sale_count</th>\n      <th>intro</th>\n      <th>address</th>\n      <th>price</th>\n      <th>discount</th>\n      <th>point</th>\n      <th>longitude</th>\n      <th>latitude</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1497883331</td>\n      <td>北京环球度假区</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>16621</td>\n      <td>大片世界，在此成真</td>\n      <td>北京市通州区北京环球度假区</td>\n      <td>505.0</td>\n      <td>8.6</td>\n      <td>116.68782,39.86099</td>\n      <td>116.687820</td>\n      <td>39.860990</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>777857128</td>\n      <td>八达岭长城</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>12285</td>\n      <td>不到长城非好汉</td>\n      <td>北京市延庆区G6京藏高速58号出口</td>\n      <td>39.5</td>\n      <td>3.9</td>\n      <td>116.024067,40.362639</td>\n      <td>116.024067</td>\n      <td>40.362639</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>4268080051</td>\n      <td>颐和园</td>\n      <td>4.1</td>\n      <td>5A</td>\n      <td>10140</td>\n      <td>走入清朝皇帝的皇家园林</td>\n      <td>北京市海淀区新建宫门路19号</td>\n      <td>30.0</td>\n      <td>10.0</td>\n      <td>116.2802339,40.0088172</td>\n      <td>116.280234</td>\n      <td>40.008817</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1699488273</td>\n      <td>北京野生动物园</td>\n      <td>3.5</td>\n      <td>4A</td>\n      <td>9962</td>\n      <td>近距离观赏野生动物</td>\n      <td>北京市大兴区榆垡镇永定河畔的万亩林</td>\n      <td>145.0</td>\n      <td>9.6</td>\n      <td>116.340954,39.502139</td>\n      <td>116.340954</td>\n      <td>39.502139</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1053903287</td>\n      <td>天坛公园</td>\n      <td>4.0</td>\n      <td>5A</td>\n      <td>8661</td>\n      <td>明清时期皇帝祭天的地方</td>\n      <td>北京市东城区天坛路甲1号</td>\n      <td>15.0</td>\n      <td>7.5</td>\n      <td>116.419289,39.889918</td>\n      <td>116.419289</td>\n      <td>39.889918</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>3070792170</td>\n      <td>恭王府</td>\n      <td>3.7</td>\n      <td>5A</td>\n      <td>6864</td>\n      <td>旧时清朝大臣和珅的府邸</td>\n      <td>北京市西城区前海西街17号</td>\n      <td>40.0</td>\n      <td>10.0</td>\n      <td>116.392599,39.943381</td>\n      <td>116.392599</td>\n      <td>39.943381</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>989946426</td>\n      <td>故宫博物院</td>\n      <td>5.0</td>\n      <td>5A</td>\n      <td>5760</td>\n      <td>穿越明清两朝的皇家宫殿群</td>\n      <td>北京市东城区景山前街4号</td>\n      <td>80.0</td>\n      <td>10.0</td>\n      <td>116.403414,39.924091</td>\n      <td>116.403414</td>\n      <td>39.924091</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>1577458228</td>\n      <td>珍宝馆</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>7433</td>\n      <td>乾隆慈禧曾居住在这</td>\n      <td>故宫博物院宁寿宫内</td>\n      <td>35.0</td>\n      <td>3.9</td>\n      <td>116.406346,39.925979</td>\n      <td>116.406346</td>\n      <td>39.925979</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>1427399043</td>\n      <td>圆明园</td>\n      <td>3.8</td>\n      <td>5A</td>\n      <td>5564</td>\n      <td>毁于战火的清代皇家园林</td>\n      <td>北京市海淀区清华西路28号</td>\n      <td>64.0</td>\n      <td>10.0</td>\n      <td>116.309736,40.016191</td>\n      <td>116.309736</td>\n      <td>40.016191</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>1987315843</td>\n      <td>慕田峪长城</td>\n      <td>3.5</td>\n      <td>5A</td>\n      <td>4673</td>\n      <td>看万里长城山河壮丽</td>\n      <td>北京市怀柔区渤海镇慕田峪村</td>\n      <td>60.0</td>\n      <td>10.0</td>\n      <td>116.575896,40.440146</td>\n      <td>116.575896</td>\n      <td>40.440146</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>2549325765</td>\n      <td>北京动物园</td>\n      <td>3.6</td>\n      <td>4A</td>\n      <td>3893</td>\n      <td>观赏众多的珍稀动物</td>\n      <td>北京市西直门外大街137号</td>\n      <td>15.0</td>\n      <td>10.0</td>\n      <td>116.342331,39.947726</td>\n      <td>116.342331</td>\n      <td>39.947726</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>89108430</td>\n      <td>鸟巢</td>\n      <td>4.2</td>\n      <td>无</td>\n      <td>4540</td>\n      <td>新北京的标志性建筑</td>\n      <td>北京市朝阳区国家体育场南路1号</td>\n      <td>94.0</td>\n      <td>9.4</td>\n      <td>116.402845,39.999285</td>\n      <td>116.402845</td>\n      <td>39.999285</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>2131323089</td>\n      <td>北海公园</td>\n      <td>3.8</td>\n      <td>4A</td>\n      <td>2951</td>\n      <td>白塔湖水相依的皇家园林</td>\n      <td>北京市西城区文津街1号</td>\n      <td>9.3</td>\n      <td>9.3</td>\n      <td>116.395006,39.934167</td>\n      <td>116.395006</td>\n      <td>39.934167</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>3318389804</td>\n      <td>中国国家博物馆</td>\n      <td>3.5</td>\n      <td>无</td>\n      <td>3716</td>\n      <td>穿越千年看中华珍宝</td>\n      <td>北京市东城区东长安街16号天安门广场东侧</td>\n      <td>138.0</td>\n      <td>10.0</td>\n      <td>116.408018,39.911449</td>\n      <td>116.408018</td>\n      <td>39.911449</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>2269763832</td>\n      <td>明十三陵</td>\n      <td>3.6</td>\n      <td>5A</td>\n      <td>2757</td>\n      <td>埋葬十三位明朝皇帝的陵园</td>\n      <td>北京市昌平区十三陵镇昌赤路</td>\n      <td>30.0</td>\n      <td>10.0</td>\n      <td>116.231846,40.263544</td>\n      <td>116.231846</td>\n      <td>40.263544</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>3770579544</td>\n      <td>景山公园</td>\n      <td>3.7</td>\n      <td>4A</td>\n      <td>2829</td>\n      <td>明朝崇祯皇帝自缢的地方</td>\n      <td>北京市西城区景山前街景山公园</td>\n      <td>6.0</td>\n      <td>10.0</td>\n      <td>116.402966,39.932136</td>\n      <td>116.402966</td>\n      <td>39.932136</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>4194325354</td>\n      <td>天安门广场</td>\n      <td>5.0</td>\n      <td>无</td>\n      <td>3234</td>\n      <td>祖国的象征与心脏</td>\n      <td>北京市东城区长安街（天安门和正阳门之间）</td>\n      <td>17.0</td>\n      <td>1.7</td>\n      <td>116.404091,39.910095</td>\n      <td>116.404091</td>\n      <td>39.910095</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>1465994645</td>\n      <td>午门</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>2771</td>\n      <td>紫禁城的正门</td>\n      <td>北京市东城区故宫博物院内</td>\n      <td>38.0</td>\n      <td>10.0</td>\n      <td>116.403705,39.920105</td>\n      <td>116.403705</td>\n      <td>39.920105</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>3389244336</td>\n      <td>北京海洋馆</td>\n      <td>3.5</td>\n      <td>4A</td>\n      <td>1690</td>\n      <td>观赏上千种水族动物</td>\n      <td>北京市海淀区高粱桥斜街乙18号</td>\n      <td>158.0</td>\n      <td>10.0</td>\n      <td>116.347445,39.950257</td>\n      <td>116.347445</td>\n      <td>39.950257</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>2769149828</td>\n      <td>北京欢乐谷</td>\n      <td>3.6</td>\n      <td>4A</td>\n      <td>1900</td>\n      <td>玩耍众多刺激的游乐项目</td>\n      <td>北京市朝阳区东四环小武基北路(欢乐谷景区地铁站B东北口步行170米)</td>\n      <td>299.0</td>\n      <td>10.0</td>\n      <td>116.501309,39.873868</td>\n      <td>116.501309</td>\n      <td>39.873868</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>1433128305</td>\n      <td>古北水镇</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>2471</td>\n      <td>在长城脚下泡温泉爬长城</td>\n      <td>北京市密云区古北口镇司马台村古北水镇 （京承高速24号司马台长城出口）</td>\n      <td>140.0</td>\n      <td>8.7</td>\n      <td>117.284632,40.661046</td>\n      <td>117.284632</td>\n      <td>40.661046</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>3125362020</td>\n      <td>雍和宫</td>\n      <td>3.8</td>\n      <td>无</td>\n      <td>2258</td>\n      <td>生活过雍正与乾隆两位皇帝</td>\n      <td>北京市东城区雍和宫大街12号</td>\n      <td>27.0</td>\n      <td>9.0</td>\n      <td>116.423776,39.953314</td>\n      <td>116.423776</td>\n      <td>39.953314</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>330194371</td>\n      <td>升旗仪式</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>2397</td>\n      <td>在天安门广场看升、降旗仪式，是游览天安门广场不可或缺的项目。每天全国各地的游客都会来此观看，...</td>\n      <td>北京市天安门广场南端</td>\n      <td>28.0</td>\n      <td>4.8</td>\n      <td>116.403931,39.913288</td>\n      <td>116.403931</td>\n      <td>39.913288</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>2732618148</td>\n      <td>中国科学技术馆</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>2271</td>\n      <td>小朋友的科学乐园</td>\n      <td>北京市朝阳区北辰东路5号</td>\n      <td>30.0</td>\n      <td>6.0</td>\n      <td>116.404938,40.012333</td>\n      <td>116.404938</td>\n      <td>40.012333</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>1504293946</td>\n      <td>北京世界公园</td>\n      <td>3.5</td>\n      <td>4A</td>\n      <td>1076</td>\n      <td>汇集各国知名建筑的微缩版</td>\n      <td>北京市丰台区花乡丰葆路158号</td>\n      <td>95.0</td>\n      <td>9.5</td>\n      <td>116.293772,39.81671</td>\n      <td>116.293772</td>\n      <td>39.816710</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>3317086974</td>\n      <td>定陵</td>\n      <td>3.6</td>\n      <td>无</td>\n      <td>2117</td>\n      <td>明代万历皇帝的大型陵墓</td>\n      <td>北京市昌平区环陵路北京十三陵风景区内盛得剧场西60米</td>\n      <td>90.0</td>\n      <td>9.0</td>\n      <td>116.232421,40.30048</td>\n      <td>116.232421</td>\n      <td>40.300480</td>\n    </tr>\n    <tr>\n      <th>60</th>\n      <td>547084149</td>\n      <td>钟表馆</td>\n      <td>0.0</td>\n      <td>无</td>\n      <td>1526</td>\n      <td>原皇帝祭祀祖先的宫殿</td>\n      <td>景山前街4号故宫博物院奉先殿</td>\n      <td>38.0</td>\n      <td>6.5</td>\n      <td>116.405192,39.925225</td>\n      <td>116.405192</td>\n      <td>39.925225</td>\n    </tr>\n    <tr>\n      <th>94</th>\n      <td>2463434580</td>\n      <td>八达岭野生动物园</td>\n      <td>3.5</td>\n      <td>无</td>\n      <td>1020</td>\n      <td>近距离观赏野生动物</td>\n      <td>北京市延庆区八达岭镇八达岭旅游区</td>\n      <td>85.0</td>\n      <td>9.4</td>\n      <td>116.001343,40.359586</td>\n      <td>116.001343</td>\n      <td>40.359586</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score = df[df['score'] > 3]\n",
    "star = score[score['star'] != '无']\n",
    "sc = star[star['sale_count'] > 1000]"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-05-31T09:31:06.198353100Z",
     "start_time": "2024-05-31T09:31:06.173416200Z"
    }
   },
   "id": "967cc85bf8845745"
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"static/data/info.csv\")\n",
    "df['年'] = df['日期'].apply(lambda x: x.split('年')[0] + '年')\n",
    "df['月份'] = df['日期'].apply(lambda x: x.split('年')[1])"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:33:29.346693400Z",
     "start_time": "2024-06-01T17:33:29.333027Z"
    }
   },
   "id": "f953c70f5444fdce"
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "outputs": [
    {
     "data": {
      "text/plain": "[{'name': '1-2月', 'value': 6214.0},\n {'name': '10月', 'value': 5228.4},\n {'name': '11月', 'value': 3965.4},\n {'name': '12月', 'value': 4672.7},\n {'name': '3月', 'value': 4687.0},\n {'name': '4月', 'value': 6436.9},\n {'name': '5月', 'value': 4851.0},\n {'name': '6月', 'value': 4818.3},\n {'name': '7月', 'value': 6205.8},\n {'name': '8月', 'value': 6529.1},\n {'name': '9月', 'value': 5248.9}]"
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month_person_count_rate = df.groupby('月份')['接待人数(万人次)'].sum().reset_index()\n",
    "{\n",
    "    'data': [{'name': i[0], 'value': round(i[1], 1)} for i in month_person_count_rate.values.tolist()]\n",
    "}\n"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:27:31.276596800Z",
     "start_time": "2024-06-01T17:27:31.261741500Z"
    }
   },
   "id": "6f49f5e1e7b0dc28"
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [
    {
     "data": {
      "text/plain": "[{'name': '门票收入(万元)', 'value': 699824.3},\n {'name': '商品销售收入(万元)', 'value': 414340.3},\n {'name': '其他收入(万元)', 'value': 844880.8}]"
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "revenue_rate = [\n",
    "    {\n",
    "        'name': '门票收入(万元)',\n",
    "        'value': round(df['门票收入(万元)'].sum(), 1)\n",
    "    },\n",
    "    {\n",
    "        'name': '商品销售收入(万元)',\n",
    "        'value': round(df['商品销售收入(万元)'].sum(), 1)\n",
    "    },\n",
    "    {\n",
    "        'name': '其他收入(万元)',\n",
    "        'value': round(df['其他收入(万元)'].sum(), 1)\n",
    "    },\n",
    "\n",
    "]\n",
    "revenue_rate"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:32:06.080883900Z",
     "start_time": "2024-06-01T17:32:06.057702200Z"
    }
   },
   "id": "1847f8717e36a39a"
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [
    {
     "data": {
      "text/plain": "['1-2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月']"
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month_revenue_trend = [df[df['年'] == i].sort_values('月份')['营业收入(万元)'].values.tolist() for i in\n",
    "                       df['年'].unique()]\n",
    "month = df['月份'].unique().tolist()"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:42:46.056143700Z",
     "start_time": "2024-06-01T17:42:46.046904400Z"
    }
   },
   "id": "45017513545189d2"
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "outputs": [
    {
     "data": {
      "text/plain": "{'label': ['8月',\n  '7月',\n  '12月',\n  '4月',\n  '5月',\n  '1-2月',\n  '6月',\n  '10月',\n  '9月',\n  '3月',\n  '11月'],\n 'value': [4248.6,\n  4229.2,\n  3994.9,\n  3982.7,\n  3758.5,\n  3588.3,\n  3422.9,\n  3322.2,\n  3158.6,\n  2877.8,\n  2827.4]}"
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person_count_rank = df[df['年'] == '2023年'].sort_values('接待人数(万人次)', ascending=False)\n",
    "{\n",
    "    'label': person_count_rank['月份'].tolist(),\n",
    "    'value': person_count_rank['接待人数(万人次)'].tolist()\n",
    "}"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:46:43.914743100Z",
     "start_time": "2024-06-01T17:46:43.903837900Z"
    }
   },
   "id": "c5239413368e6f5e"
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "outputs": [
    {
     "data": {
      "text/plain": "(74.4, 102.7)"
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_on_year_growth_revenue_rate = (df[df['年'] == '2023年']['营业收入(万元)'].sum() - df[df['年'] == '2022年'][\n",
    "    '营业收入(万元)'].sum()) / df[df['年'] == '2022年']['营业收入(万元)'].sum()\n",
    "year_on_year_growth_person_rate = (df[df['年'] == '2023年']['接待人数(万人次)'].sum() - df[df['年'] == '2022年'][\n",
    "    '接待人数(万人次)'].sum()) / df[df['年'] == '2022年']['接待人数(万人次)'].sum()\n",
    "{\n",
    "    'label': ['年营业收入', '年接待人数'],\n",
    "    'value': [round(year_on_year_growth_revenue_rate * 100, 1), round(year_on_year_growth_person_rate * 100, 1)]\n",
    "}"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T17:58:22.616464500Z",
     "start_time": "2024-06-01T17:58:22.591419900Z"
    }
   },
   "id": "dad079d01075f385"
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "outputs": [
    {
     "data": {
      "text/plain": "5000"
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month_person_count_radar = [df[df['年'] == i]['接待人数(万人次)'].values.tolist() for i in df['年'].unique()]\n",
    "# month = df['月份'].unique().tolist()\n",
    "count_max =  df['接待人数(万人次)'].max()\n",
    "10**(len(str(int(count_max)))-1)*(int(str(int(count_max))[0])+1)"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-06-01T18:15:45.947721400Z",
     "start_time": "2024-06-01T18:15:45.941870900Z"
    }
   },
   "id": "9c7b2bb5dc50ebbb"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
